package com.interauto.Dao.Mapper;

import com.interauto.Dao.entity.Caseinfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.mybatis.spring.annotation.MapperScan;

import java.util.List;

@Mapper
public interface CaseStInter {
    @Select("select * from caseinfo where id=#{id} and delstatus=0")
    Caseinfo getCaseinfo(@Param(value = "id") int id);

    @Select("select * from caseinfo where projectid=#{projectid} and delstatus=0 order by createtime DESC")
    List<Caseinfo> getForProjectid(@Param(value = "projectid") int id);
}
